package com.itheima.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.itheima.pojo.Member;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface MemberMapper extends BaseMapper<Member> {

    @Select("select phoneNumber from t_member where phoneNumber=#{telephone}")
    Member findByTelephone(@Param("telephone") String telephone);

    @Select("select * from t_member where PHONENUMBER = #{telephone}")
    Member findMemberByTelephone(@Param("telephone") String telephone);

    @Select("SELECT count(*) FROM t_member where REGTIME BETWEEN #{bigDate} AND #{endDate}")

    int findMemberCount(@Param("bigDate") String bigDate, @Param("endDate") String endDate);
}
